﻿using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
namespace INTEX.DataBase.Tools
{
    public partial class INTEXDBC
    {
        public void MapVVTLIEF(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public void SaveVVTLIEF(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;
            DataRow dwLocal = null;
            bool flgExist = false;
            setResult = QueryVVTLIEF(dwData);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                    dwLocal = tbLocal.Rows[0];
                }
                else
                {
                    dwLocal = tbLocal.NewRow();
                }
            }
            MapVVTLIEF(ref dwLocal, dwData);

            if (!flgExist)
            {
                InsertVVTLIEF(dwLocal, ITXDBVERSION);
            }
            UpdateVVTLIEF(dwLocal);
        }
        public void InsertVVTLIEF(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "50.24":
                    or1.CommandText = "INSERT INTO VVTLIEF(VVTMANDANT, VVTAUFTYP, VVTAUFKRS, VVTAUFLFD, VVTAUFPOS, VVTTEILNR, VVTLOVON, VVTLOAN, VVTTEILNRAN, VVTABHAENGIG, VVTLOABH1, VVTLOABH2, VVTPRODST, VVTKZINLEXP, VVTLAND, VVTPLZ, VVTKUNDNRL, VVTADRSLL, VVTLIEFSCH, VVTLIEFSCHPOS, VVTKUNDNRR, VVTADRSLR, VVTRENR, VVTPFRENR, VVTME, VVTANZSTK, VVTMTR, VVTKG, VVTQM, VVTRUECKANZSTK, VVTRUECKMTR, VVTRUECKKG, VVTRUECKQM, VVTANZVP, VVTLB1, VVTLB2, VVTLB3, VVTLB4, VVTLB5, VVTLB6, VVTZAHLBED, VVTVALUTA, VVTVALDAT, VVTEKON, VVTLIEFBED, VVTLANDU, VVTPLZU, VVTORTU, VVTBZU, VVTBZBEZU, VVTCOUNTYU, VVTCITYU, VVTVERSART, VVTVERPART, VVTLIEFSCHGRP, VVTSTKPA, VVTSPED, VVTPRKZ, VVTDRKZ, VVTDRDAT, VVTAFOLGEV, VVTVB, VVTORT, VVTBZ, VVTBZBEZ, VVTCOUNTY, VVTCITY, VVTREGRP, VVTKDVKL, VVTANAME1, VVTANAME2, VVTASTRASSE1, VVTASTRASSE2, VVTALAND, VVTAPLZ, VVTAORT, VVTABZ, VVTABZBEZ, VVTACOUNTY, VVTACITY, VVTKZVVERP, VVTPRIO, VVTKUNDLO, VVTKUNDLB, VVTKUNDLP, VVTKDBEZKZ, VVTREPOS, VVTVERS, VVTPARTIE, VVTPARTIEKZ, VVTRESTKZ, VVTFORT, VVTKDAUFTNR, VVTKDAUFDAT, VVTPOSTYP, VVTKUNDNR, VVTWERK, VVTABT, VVTWAKZ, VVTART, VVTVAR, VVTFARBE, VVTDESS, VVTCOL, VVTBESCH, VVTGROE, VVTAUFM, VVTSETKZ, VVTLOHNKD, VVTKOLL, VVTSANZSTK, VVTROHMTR, VVTBRUTTO, VVTNETTO, VVTVERDERB, VVTFOLGEMTR, VVTSOLLTEIL, VVTGEBNR, VVTPROGRP, VVTPLFDAT, VVTFBENID, VVTFDAT, VVTFZEIT, VVTVBDAT, VVTLIEFTERM, VVTEILAUS, VVTFRNETTO, VVTHUELTYP, VVTHUELGEW, VVTSPULEN, VVTNETKG, VVTFEUCHTEI, VVTFEUCHTES, VVTHGEWABZ, VVTANZPA, VVTTARA, VVTBRTGEW, VVTPACKTYP, VVTKREDLIM, VVTSWING, VVTRAITING, VVTVERSICH1, VVTVERSICH2, VVTVERSICH3, VVTVERSICH4, VVTVERSICH5, VVTVERSICH21, VVTVERSICH22, VVTVERSICH23, VVTVERSICH24, VVTVERSICH25, VVTKREDBIS, VVTKREDVON, VVTLUEBKZ, VVTFKNVS, VVTFKSPTD, VVTFKSPRD, VVTROHGEW, VVTFERGEW, VVTZUSTAND, VVTARTGRP, VVTARTABW, VVTAPOS, VVTAUFMSL, VVTZENSUR, VVTPOSEXT, VVTKZZUTEI, VVTAKKREDNR, VVTFILLER1)"
                        + " VALUES (:VVTMANDANT, 'K', :VVTAUFKRS, :VVTAUFLFD, :VVTAUFPOS, '0001', '01', '  ', 0, 0, '  ', '  ', 'G', 'E', 'CN ', '            ', '00000200', '        ', :VVTLIEFSCH, :VVTLIEFSCHPOS, '00000200', '        ', '00000000', '00000000', 'KG ', 0, 0, '0000450000', '0000000000', 0, 0, '0000000000', '0000000000', 0, 'YN', '  ', '  ', '  ', '  ', '  ', 'STD', 0, 0, '        ', 'EXW', 'CN ', '42115       ', 'Jiangyin                                ', '1 ', 'Jiangyin     ', '    ', '    ', 'INT', '   ', ' ', 30, 'LKW', '  ', ' ', 0, 0, 'RMB', '·eé?                                    ', '  ', '             ', '    ', '    ', ' ', '   ', '                                        ', '                                        ', '                                        ', '                                        ', '   ', '            ', '                                        ', '  ', '             ', '    ', '    ', 'N', '9', '  ', '  ', '        ', ' ', '000', ' ', '       ', ' ', ' ', 0, '                    ', 0, '   ', '        ', '   ', '   ', 'V', '19009.30.3              ', '   ', '1M0300    ', '          ', '          ', '          ', '       ', '  ', ' ', '        ', 'JMK10', 0, 0, 0, 0, 0, 0, 0, '        ', '   ', 20110206, 'SUNLV   ', 20120825, 1555, 20110206, 20110206, ' ', 0, '      ', 0, 0, '0000450000', 1825, 1825, 'J', 0, 0, 0, '    ', '0090000000', '0089728588', '003', '01', '  ', '  ', '  ', '  ', '  ', '  ', '  ', '  ', '  ', 20231212, 0, ' ', ' ', 0, 0, 0, 0, '    ', '   ', ' ', '0000', '  ', '  ', '000000', ' ', '                    ', '                                                     ')";
                    break;
                default:
                    break;
            }
            or1.Parameters.Add("VVTMANDANT", OracleType.NVarChar).Value = dwData["VVTMANDANT"].ToString();
            or1.Parameters.Add("VVTLIEFSCH", OracleType.NVarChar).Value = dwData["VVTLIEFSCH"].ToString();
            or1.Parameters.Add("VVTLIEFSCHPOS", OracleType.NVarChar).Value = dwData["VVTLIEFSCHPOS"].ToString();
            or1.Parameters.Add("VVTAUFKRS", OracleType.NVarChar).Value = dwData["VVTAUFKRS"].ToString();
            or1.Parameters.Add("VVTAUFLFD", OracleType.NVarChar).Value = dwData["VVTAUFLFD"].ToString();
            or1.Parameters.Add("VVTAUFPOS", OracleType.NVarChar).Value = dwData["VVTAUFPOS"].ToString();

            Connect2Proxy(or1);
        } 
        public DataSet QueryVVTLIEF(DataRow dwData, int option = 1)
        {
            DataSet Return = new DataSet();
            DataTable tbLocal = null;
            DataSet Result = new DataSet();
            string table = "VVTLIEF";

            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM VVTLIEF WHERE  ROWNUM<2 ";
                    break;
                case 1:
                    or1.CommandText = "SELECT * FROM VVTLIEF WHERE VVTMANDANT=:VVTMANDANT AND VVTLIEFSCH=:VVTLIEFSCH AND VVTLIEFSCHPOS=:VVTLIEFSCHPOS";
                    or1.Parameters.Add("VVTMANDANT", OracleType.NVarChar).Value = dwData["VVTMANDANT"].ToString();
                    or1.Parameters.Add("VVTLIEFSCH", OracleType.NVarChar).Value = dwData["VVTLIEFSCH"].ToString();
                    or1.Parameters.Add("VVTLIEFSCHPOS", OracleType.NVarChar).Value = dwData["VVTLIEFSCHPOS"].ToString();
                    break;
                case 2:
                    or1.CommandText = "SELECT * "
                                       + " FROM VVTLIEF   WHERE "
                                       + " VVTAUFKRS = :VVTAUFKRS AND VVTAUFLFD = :VVTAUFLFD ";
                    or1.Parameters.Add("VVTAUFKRS", OracleType.NVarChar).Value = dwData["VVTAUFKRS"].ToString();
                    or1.Parameters.Add("VVTAUFLFD", OracleType.NVarChar).Value = dwData["VVTAUFLFD"].ToString();
                    break;
                case 3:
                    or1.CommandText = "SELECT * FROM VVTLIEF WHERE VVTMANDANT=:VVTMANDANT AND VVTLIEFSCH=:VVTLIEFSCH";
                    or1.Parameters.Add("VVTMANDANT", OracleType.NVarChar).Value = dwData["VVTMANDANT"].ToString();
                    or1.Parameters.Add("VVTLIEFSCH", OracleType.NVarChar).Value = dwData["VVTLIEFSCH"].ToString();
                    break;
                case 4:
                    or1.CommandText = "SELECT DISTINCT R.VRPRENR,VRPREPOS,VRPAUFKRS,VRPAUFLFD,VRPAUFPOS,VV.* "
                    + " FROM VRPOS R JOIN VVTLIEF VV ON R.VRPLIEFSCH=VV.VVTLIEFSCH"
                    + " WHERE VRPMANDANT=:VRPMANDANT AND VRPRENR = :VRPRENR ";
                    or1.Parameters.Add("VRPMANDANT", OracleType.NVarChar).Value = dwData["VRPMANDANT"].ToString();
                    or1.Parameters.Add("VRPRENR", OracleType.NVarChar).Value = dwData["VRPRENR"].ToString();
                    break;
                case 5:
                    or1.CommandText = "SELECT VVLIEFSCH,T.* FROM VVTLIEF T JOIN VVLIEF ON VVLIEFSCH=VVTLIEFSCH WHERE  VVNEUDAT>='" + dwData["DSTART"].ToString() + "' AND VVNEUDAT<='" + dwData["DEND"].ToString() + "' AND VVSTATUS IN (" + dwData["C20"].ToString() + ")"; 
                     break; 
            }
            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
            {
                tbLocal = Result.Tables[0];
                tbLocal.TableName = "VVTLIEF";
            }
            Return.Merge(Result);

            return Return;
        }
        public void UpdateVVTLIEF(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            DataSet result = new DataSet();
            or1 = OracleDB.CreateCommand();

            #region====Command====
            or1.CommandText = "UPDATE VVTLIEF SET "
                + "VVTMANDANT=:VVTMANDANT,"
                + "VVTAUFTYP=:VVTAUFTYP,"
                + "VVTAUFKRS=:VVTAUFKRS,"
                + "VVTAUFLFD=:VVTAUFLFD,"
                + "VVTAUFPOS=:VVTAUFPOS,"
                + "VVTTEILNR=:VVTTEILNR,"
                + "VVTLOVON=:VVTLOVON,"
                + "VVTLOAN=:VVTLOAN,"
                + "VVTTEILNRAN=:VVTTEILNRAN,"
                + "VVTABHAENGIG=:VVTABHAENGIG,"
                + "VVTLOABH1=:VVTLOABH1,"
                + "VVTLOABH2=:VVTLOABH2,"
                + "VVTPRODST=:VVTPRODST,"
                + "VVTKZINLEXP=:VVTKZINLEXP,"
                + "VVTLAND=:VVTLAND,"
                + "VVTPLZ=:VVTPLZ,"
                + "VVTKUNDNRL=:VVTKUNDNRL,"
                + "VVTADRSLL=:VVTADRSLL,"
                + "VVTLIEFSCH=:VVTLIEFSCH,"
                + "VVTLIEFSCHPOS=:VVTLIEFSCHPOS,"
                + "VVTKUNDNRR=:VVTKUNDNRR,"
                + "VVTADRSLR=:VVTADRSLR,"
                + "VVTRENR=:VVTRENR,"
                + "VVTPFRENR=:VVTPFRENR,"
                + "VVTME=:VVTME,"
                + "VVTANZSTK=:VVTANZSTK,"
                + "VVTMTR=:VVTMTR,"
                + "VVTKG=:VVTKG,"
                + "VVTQM=:VVTQM,"
                + "VVTRUECKANZSTK=:VVTRUECKANZSTK,"
                + "VVTRUECKMTR=:VVTRUECKMTR,"
                + "VVTRUECKKG=:VVTRUECKKG,"
                + "VVTRUECKQM=:VVTRUECKQM,"
                + "VVTANZVP=:VVTANZVP,"
                + "VVTLB1=:VVTLB1,"
                + "VVTLB2=:VVTLB2,"
                + "VVTLB3=:VVTLB3,"
                + "VVTLB4=:VVTLB4,"
                + "VVTLB5=:VVTLB5,"
                + "VVTLB6=:VVTLB6,"
                + "VVTZAHLBED=:VVTZAHLBED,"
                + "VVTVALUTA=:VVTVALUTA,"
                + "VVTVALDAT=:VVTVALDAT,"
                + "VVTEKON=:VVTEKON,"
                + "VVTLIEFBED=:VVTLIEFBED,"
                + "VVTLANDU=:VVTLANDU,"
                + "VVTPLZU=:VVTPLZU,"
                + "VVTORTU=:VVTORTU,"
                + "VVTBZU=:VVTBZU,"
                + "VVTBZBEZU=:VVTBZBEZU,"
                + "VVTCOUNTYU=:VVTCOUNTYU,"
                + "VVTCITYU=:VVTCITYU,"
                + "VVTVERSART=:VVTVERSART,"
                + "VVTVERPART=:VVTVERPART,"
                + "VVTLIEFSCHGRP=:VVTLIEFSCHGRP,"
                + "VVTSTKPA=:VVTSTKPA,"
                + "VVTSPED=:VVTSPED,"
                + "VVTPRKZ=:VVTPRKZ,"
                + "VVTDRKZ=:VVTDRKZ,"
                + "VVTDRDAT=:VVTDRDAT,"
                + "VVTAFOLGEV=:VVTAFOLGEV,"
                + "VVTVB=:VVTVB,"
                + "VVTORT=:VVTORT,"
                + "VVTBZ=:VVTBZ,"
                + "VVTBZBEZ=:VVTBZBEZ,"
                + "VVTCOUNTY=:VVTCOUNTY,"
                + "VVTCITY=:VVTCITY,"
                + "VVTREGRP=:VVTREGRP,"
                + "VVTKDVKL=:VVTKDVKL,"
                + "VVTANAME1=:VVTANAME1,"
                + "VVTANAME2=:VVTANAME2,"
                + "VVTASTRASSE1=:VVTASTRASSE1,"
                + "VVTASTRASSE2=:VVTASTRASSE2,"
                + "VVTALAND=:VVTALAND,"
                + "VVTAPLZ=:VVTAPLZ,"
                + "VVTAORT=:VVTAORT,"
                + "VVTABZ=:VVTABZ,"
                + "VVTABZBEZ=:VVTABZBEZ,"
                + "VVTACOUNTY=:VVTACOUNTY,"
                + "VVTACITY=:VVTACITY,"
                + "VVTKZVVERP=:VVTKZVVERP,"
                + "VVTPRIO=:VVTPRIO,"
                + "VVTKUNDLO=:VVTKUNDLO,"
                + "VVTKUNDLB=:VVTKUNDLB,"
                + "VVTKUNDLP=:VVTKUNDLP,"
                + "VVTKDBEZKZ=:VVTKDBEZKZ,"
                + "VVTREPOS=:VVTREPOS,"
                + "VVTVERS=:VVTVERS,"
                + "VVTPARTIE=:VVTPARTIE,"
                + "VVTPARTIEKZ=:VVTPARTIEKZ,"
                + "VVTRESTKZ=:VVTRESTKZ,"
                + "VVTFORT=:VVTFORT,"
                + "VVTKDAUFTNR=:VVTKDAUFTNR,"
                + "VVTKDAUFDAT=:VVTKDAUFDAT,"
                + "VVTPOSTYP=:VVTPOSTYP,"
                + "VVTKUNDNR=:VVTKUNDNR,"
                + "VVTWERK=:VVTWERK,"
                + "VVTABT=:VVTABT,"
                + "VVTWAKZ=:VVTWAKZ,"
                + "VVTART=:VVTART,"
                + "VVTVAR=:VVTVAR,"
                + "VVTFARBE=:VVTFARBE,"
                + "VVTDESS=:VVTDESS,"
                + "VVTCOL=:VVTCOL,"
                + "VVTBESCH=:VVTBESCH,"
                + "VVTGROE=:VVTGROE,"
                + "VVTAUFM=:VVTAUFM,"
                + "VVTSETKZ=:VVTSETKZ,"
                + "VVTLOHNKD=:VVTLOHNKD,"
                + "VVTKOLL=:VVTKOLL,"
                + "VVTSANZSTK=:VVTSANZSTK,"
                + "VVTROHMTR=:VVTROHMTR,"
                + "VVTBRUTTO=:VVTBRUTTO,"
                + "VVTNETTO=:VVTNETTO,"
                + "VVTVERDERB=:VVTVERDERB,"
                + "VVTFOLGEMTR=:VVTFOLGEMTR,"
                + "VVTSOLLTEIL=:VVTSOLLTEIL,"
                + "VVTGEBNR=:VVTGEBNR,"
                + "VVTPROGRP=:VVTPROGRP,"
                + "VVTPLFDAT=:VVTPLFDAT,"
                + "VVTFBENID=:VVTFBENID,"
                + "VVTFDAT=:VVTFDAT,"
                + "VVTFZEIT=:VVTFZEIT,"
                + "VVTVBDAT=:VVTVBDAT,"
                + "VVTLIEFTERM=:VVTLIEFTERM,"
                + "VVTEILAUS=:VVTEILAUS,"
                + "VVTFRNETTO=:VVTFRNETTO,"
                + "VVTHUELTYP=:VVTHUELTYP,"
                + "VVTHUELGEW=:VVTHUELGEW,"
                + "VVTSPULEN=:VVTSPULEN,"
                + "VVTNETKG=:VVTNETKG,"
                + "VVTFEUCHTEI=:VVTFEUCHTEI,"
                + "VVTFEUCHTES=:VVTFEUCHTES,"
                + "VVTHGEWABZ=:VVTHGEWABZ,"
                + "VVTANZPA=:VVTANZPA,"
                + "VVTTARA=:VVTTARA,"
                + "VVTBRTGEW=:VVTBRTGEW,"
                + "VVTPACKTYP=:VVTPACKTYP,"
                + "VVTKREDLIM=:VVTKREDLIM,"
                + "VVTSWING=:VVTSWING,"
                + "VVTRAITING=:VVTRAITING,"
                + "VVTVERSICH1=:VVTVERSICH1,"
                + "VVTVERSICH2=:VVTVERSICH2,"
                + "VVTVERSICH3=:VVTVERSICH3,"
                + "VVTVERSICH4=:VVTVERSICH4,"
                + "VVTVERSICH5=:VVTVERSICH5,"
                + "VVTVERSICH21=:VVTVERSICH21,"
                + "VVTVERSICH22=:VVTVERSICH22,"
                + "VVTVERSICH23=:VVTVERSICH23,"
                + "VVTVERSICH24=:VVTVERSICH24,"
                + "VVTVERSICH25=:VVTVERSICH25,"
                + "VVTKREDBIS=:VVTKREDBIS,"
                + "VVTKREDVON=:VVTKREDVON,"
                + "VVTLUEBKZ=:VVTLUEBKZ,"
                + "VVTFKNVS=:VVTFKNVS,"
                + "VVTFKSPTD=:VVTFKSPTD,"
                + "VVTFKSPRD=:VVTFKSPRD,"
                + "VVTROHGEW=:VVTROHGEW,"
                + "VVTFERGEW=:VVTFERGEW,"
                + "VVTZUSTAND=:VVTZUSTAND,"
                + "VVTARTGRP=:VVTARTGRP,"
                + "VVTARTABW=:VVTARTABW,"
                + "VVTAPOS=:VVTAPOS,"
                + "VVTAUFMSL=:VVTAUFMSL,"
                + "VVTZENSUR=:VVTZENSUR,"
                + "VVTPOSEXT=:VVTPOSEXT,"
                + "VVTKZZUTEI=:VVTKZZUTEI,"
                + "VVTAKKREDNR=:VVTAKKREDNR,"
                + "VVTFILLER1=:VVTFILLER1"
                + " WHERE  "
                + "  VVTMANDANT=:VVTMANDANT AND VVTLIEFSCH=:VVTLIEFSCH AND VVTLIEFSCHPOS=:VVTLIEFSCHPOS";
            #endregion

            #region====Parameters====
            or1.Parameters.Add("VVTMANDANT", OracleType.NVarChar).Value = dwData["VVTMANDANT"].ToString();
            or1.Parameters.Add("VVTAUFTYP", OracleType.NVarChar).Value = dwData["VVTAUFTYP"].ToString();
            or1.Parameters.Add("VVTAUFKRS", OracleType.NVarChar).Value = dwData["VVTAUFKRS"].ToString();
            or1.Parameters.Add("VVTAUFLFD", OracleType.NVarChar).Value = dwData["VVTAUFLFD"].ToString();
            or1.Parameters.Add("VVTAUFPOS", OracleType.NVarChar).Value = dwData["VVTAUFPOS"].ToString();
            or1.Parameters.Add("VVTTEILNR", OracleType.NVarChar).Value = dwData["VVTTEILNR"].ToString();
            or1.Parameters.Add("VVTLOVON", OracleType.NVarChar).Value = dwData["VVTLOVON"].ToString();
            or1.Parameters.Add("VVTLOAN", OracleType.NVarChar).Value = dwData["VVTLOAN"].ToString();
            or1.Parameters.Add("VVTTEILNRAN", OracleType.NVarChar).Value = dwData["VVTTEILNRAN"].ToString();
            or1.Parameters.Add("VVTABHAENGIG", OracleType.NVarChar).Value = dwData["VVTABHAENGIG"].ToString();
            or1.Parameters.Add("VVTLOABH1", OracleType.NVarChar).Value = dwData["VVTLOABH1"].ToString();
            or1.Parameters.Add("VVTLOABH2", OracleType.NVarChar).Value = dwData["VVTLOABH2"].ToString();
            or1.Parameters.Add("VVTPRODST", OracleType.NVarChar).Value = dwData["VVTPRODST"].ToString();
            or1.Parameters.Add("VVTKZINLEXP", OracleType.NVarChar).Value = dwData["VVTKZINLEXP"].ToString();
            or1.Parameters.Add("VVTLAND", OracleType.NVarChar).Value = dwData["VVTLAND"].ToString();
            or1.Parameters.Add("VVTPLZ", OracleType.NVarChar).Value = dwData["VVTPLZ"].ToString();
            or1.Parameters.Add("VVTKUNDNRL", OracleType.NVarChar).Value = dwData["VVTKUNDNRL"].ToString();
            or1.Parameters.Add("VVTADRSLL", OracleType.NVarChar).Value = dwData["VVTADRSLL"].ToString();
            or1.Parameters.Add("VVTLIEFSCH", OracleType.NVarChar).Value = dwData["VVTLIEFSCH"].ToString();
            or1.Parameters.Add("VVTLIEFSCHPOS", OracleType.NVarChar).Value = dwData["VVTLIEFSCHPOS"].ToString();
            or1.Parameters.Add("VVTKUNDNRR", OracleType.NVarChar).Value = dwData["VVTKUNDNRR"].ToString();
            or1.Parameters.Add("VVTADRSLR", OracleType.NVarChar).Value = dwData["VVTADRSLR"].ToString();
            or1.Parameters.Add("VVTRENR", OracleType.NVarChar).Value = dwData["VVTRENR"].ToString();
            or1.Parameters.Add("VVTPFRENR", OracleType.NVarChar).Value = dwData["VVTPFRENR"].ToString();
            or1.Parameters.Add("VVTME", OracleType.NVarChar).Value = dwData["VVTME"].ToString();
            or1.Parameters.Add("VVTANZSTK", OracleType.NVarChar).Value = dwData["VVTANZSTK"].ToString();
            or1.Parameters.Add("VVTMTR", OracleType.NVarChar).Value = dwData["VVTMTR"].ToString();
            or1.Parameters.Add("VVTKG", OracleType.NVarChar).Value = dwData["VVTKG"].ToString();
            or1.Parameters.Add("VVTQM", OracleType.NVarChar).Value = dwData["VVTQM"].ToString();
            or1.Parameters.Add("VVTRUECKANZSTK", OracleType.NVarChar).Value = dwData["VVTRUECKANZSTK"].ToString();
            or1.Parameters.Add("VVTRUECKMTR", OracleType.NVarChar).Value = dwData["VVTRUECKMTR"].ToString();
            or1.Parameters.Add("VVTRUECKKG", OracleType.NVarChar).Value = dwData["VVTRUECKKG"].ToString();
            or1.Parameters.Add("VVTRUECKQM", OracleType.NVarChar).Value = dwData["VVTRUECKQM"].ToString();
            or1.Parameters.Add("VVTANZVP", OracleType.NVarChar).Value = dwData["VVTANZVP"].ToString();
            or1.Parameters.Add("VVTLB1", OracleType.NVarChar).Value = dwData["VVTLB1"].ToString();
            or1.Parameters.Add("VVTLB2", OracleType.NVarChar).Value = dwData["VVTLB2"].ToString();
            or1.Parameters.Add("VVTLB3", OracleType.NVarChar).Value = dwData["VVTLB3"].ToString();
            or1.Parameters.Add("VVTLB4", OracleType.NVarChar).Value = dwData["VVTLB4"].ToString();
            or1.Parameters.Add("VVTLB5", OracleType.NVarChar).Value = dwData["VVTLB5"].ToString();
            or1.Parameters.Add("VVTLB6", OracleType.NVarChar).Value = dwData["VVTLB6"].ToString();
            or1.Parameters.Add("VVTZAHLBED", OracleType.NVarChar).Value = dwData["VVTZAHLBED"].ToString();
            or1.Parameters.Add("VVTVALUTA", OracleType.NVarChar).Value = dwData["VVTVALUTA"].ToString();
            or1.Parameters.Add("VVTVALDAT", OracleType.NVarChar).Value = dwData["VVTVALDAT"].ToString();
            or1.Parameters.Add("VVTEKON", OracleType.NVarChar).Value = dwData["VVTEKON"].ToString();
            or1.Parameters.Add("VVTLIEFBED", OracleType.NVarChar).Value = dwData["VVTLIEFBED"].ToString();
            or1.Parameters.Add("VVTLANDU", OracleType.NVarChar).Value = dwData["VVTLANDU"].ToString();
            or1.Parameters.Add("VVTPLZU", OracleType.NVarChar).Value = dwData["VVTPLZU"].ToString();
            or1.Parameters.Add("VVTORTU", OracleType.NVarChar).Value = dwData["VVTORTU"].ToString();
            or1.Parameters.Add("VVTBZU", OracleType.NVarChar).Value = dwData["VVTBZU"].ToString();
            or1.Parameters.Add("VVTBZBEZU", OracleType.NVarChar).Value = dwData["VVTBZBEZU"].ToString();
            or1.Parameters.Add("VVTCOUNTYU", OracleType.NVarChar).Value = dwData["VVTCOUNTYU"].ToString();
            or1.Parameters.Add("VVTCITYU", OracleType.NVarChar).Value = dwData["VVTCITYU"].ToString();
            or1.Parameters.Add("VVTVERSART", OracleType.NVarChar).Value = dwData["VVTVERSART"].ToString();
            or1.Parameters.Add("VVTVERPART", OracleType.NVarChar).Value = dwData["VVTVERPART"].ToString();
            or1.Parameters.Add("VVTLIEFSCHGRP", OracleType.NVarChar).Value = dwData["VVTLIEFSCHGRP"].ToString();
            or1.Parameters.Add("VVTSTKPA", OracleType.NVarChar).Value = dwData["VVTSTKPA"].ToString();
            or1.Parameters.Add("VVTSPED", OracleType.NVarChar).Value = dwData["VVTSPED"].ToString();
            or1.Parameters.Add("VVTPRKZ", OracleType.NVarChar).Value = dwData["VVTPRKZ"].ToString();
            or1.Parameters.Add("VVTDRKZ", OracleType.NVarChar).Value = dwData["VVTDRKZ"].ToString();
            or1.Parameters.Add("VVTDRDAT", OracleType.NVarChar).Value = dwData["VVTDRDAT"].ToString();
            or1.Parameters.Add("VVTAFOLGEV", OracleType.NVarChar).Value = dwData["VVTAFOLGEV"].ToString();
            or1.Parameters.Add("VVTVB", OracleType.NVarChar).Value = dwData["VVTVB"].ToString();
            or1.Parameters.Add("VVTORT", OracleType.NVarChar).Value = dwData["VVTORT"].ToString();
            or1.Parameters.Add("VVTBZ", OracleType.NVarChar).Value = dwData["VVTBZ"].ToString();
            or1.Parameters.Add("VVTBZBEZ", OracleType.NVarChar).Value = dwData["VVTBZBEZ"].ToString();
            or1.Parameters.Add("VVTCOUNTY", OracleType.NVarChar).Value = dwData["VVTCOUNTY"].ToString();
            or1.Parameters.Add("VVTCITY", OracleType.NVarChar).Value = dwData["VVTCITY"].ToString();
            or1.Parameters.Add("VVTREGRP", OracleType.NVarChar).Value = dwData["VVTREGRP"].ToString();
            or1.Parameters.Add("VVTKDVKL", OracleType.NVarChar).Value = dwData["VVTKDVKL"].ToString();
            or1.Parameters.Add("VVTANAME1", OracleType.NVarChar).Value = dwData["VVTANAME1"].ToString();
            or1.Parameters.Add("VVTANAME2", OracleType.NVarChar).Value = dwData["VVTANAME2"].ToString();
            or1.Parameters.Add("VVTASTRASSE1", OracleType.NVarChar).Value = dwData["VVTASTRASSE1"].ToString();
            or1.Parameters.Add("VVTASTRASSE2", OracleType.NVarChar).Value = dwData["VVTASTRASSE2"].ToString();
            or1.Parameters.Add("VVTALAND", OracleType.NVarChar).Value = dwData["VVTALAND"].ToString();
            or1.Parameters.Add("VVTAPLZ", OracleType.NVarChar).Value = dwData["VVTAPLZ"].ToString();
            or1.Parameters.Add("VVTAORT", OracleType.NVarChar).Value = dwData["VVTAORT"].ToString();
            or1.Parameters.Add("VVTABZ", OracleType.NVarChar).Value = dwData["VVTABZ"].ToString();
            or1.Parameters.Add("VVTABZBEZ", OracleType.NVarChar).Value = dwData["VVTABZBEZ"].ToString();
            or1.Parameters.Add("VVTACOUNTY", OracleType.NVarChar).Value = dwData["VVTACOUNTY"].ToString();
            or1.Parameters.Add("VVTACITY", OracleType.NVarChar).Value = dwData["VVTACITY"].ToString();
            or1.Parameters.Add("VVTKZVVERP", OracleType.NVarChar).Value = dwData["VVTKZVVERP"].ToString();
            or1.Parameters.Add("VVTPRIO", OracleType.NVarChar).Value = dwData["VVTPRIO"].ToString();
            or1.Parameters.Add("VVTKUNDLO", OracleType.NVarChar).Value = dwData["VVTKUNDLO"].ToString();
            or1.Parameters.Add("VVTKUNDLB", OracleType.NVarChar).Value = dwData["VVTKUNDLB"].ToString();
            or1.Parameters.Add("VVTKUNDLP", OracleType.NVarChar).Value = dwData["VVTKUNDLP"].ToString();
            or1.Parameters.Add("VVTKDBEZKZ", OracleType.NVarChar).Value = dwData["VVTKDBEZKZ"].ToString();
            or1.Parameters.Add("VVTREPOS", OracleType.NVarChar).Value = dwData["VVTREPOS"].ToString();
            or1.Parameters.Add("VVTVERS", OracleType.NVarChar).Value = dwData["VVTVERS"].ToString();
            or1.Parameters.Add("VVTPARTIE", OracleType.NVarChar).Value = dwData["VVTPARTIE"].ToString();
            or1.Parameters.Add("VVTPARTIEKZ", OracleType.NVarChar).Value = dwData["VVTPARTIEKZ"].ToString();
            or1.Parameters.Add("VVTRESTKZ", OracleType.NVarChar).Value = dwData["VVTRESTKZ"].ToString();
            or1.Parameters.Add("VVTFORT", OracleType.NVarChar).Value = dwData["VVTFORT"].ToString();
            or1.Parameters.Add("VVTKDAUFTNR", OracleType.NVarChar).Value = dwData["VVTKDAUFTNR"].ToString();
            or1.Parameters.Add("VVTKDAUFDAT", OracleType.NVarChar).Value = dwData["VVTKDAUFDAT"].ToString();
            or1.Parameters.Add("VVTPOSTYP", OracleType.NVarChar).Value = dwData["VVTPOSTYP"].ToString();
            or1.Parameters.Add("VVTKUNDNR", OracleType.NVarChar).Value = dwData["VVTKUNDNR"].ToString();
            or1.Parameters.Add("VVTWERK", OracleType.NVarChar).Value = dwData["VVTWERK"].ToString();
            or1.Parameters.Add("VVTABT", OracleType.NVarChar).Value = dwData["VVTABT"].ToString();
            or1.Parameters.Add("VVTWAKZ", OracleType.NVarChar).Value = dwData["VVTWAKZ"].ToString();
            or1.Parameters.Add("VVTART", OracleType.NVarChar).Value = dwData["VVTART"].ToString();
            or1.Parameters.Add("VVTVAR", OracleType.NVarChar).Value = dwData["VVTVAR"].ToString();
            or1.Parameters.Add("VVTFARBE", OracleType.NVarChar).Value = dwData["VVTFARBE"].ToString();
            or1.Parameters.Add("VVTDESS", OracleType.NVarChar).Value = dwData["VVTDESS"].ToString();
            or1.Parameters.Add("VVTCOL", OracleType.NVarChar).Value = dwData["VVTCOL"].ToString();
            or1.Parameters.Add("VVTBESCH", OracleType.NVarChar).Value = dwData["VVTBESCH"].ToString();
            or1.Parameters.Add("VVTGROE", OracleType.NVarChar).Value = dwData["VVTGROE"].ToString();
            or1.Parameters.Add("VVTAUFM", OracleType.NVarChar).Value = dwData["VVTAUFM"].ToString();
            or1.Parameters.Add("VVTSETKZ", OracleType.NVarChar).Value = dwData["VVTSETKZ"].ToString();
            or1.Parameters.Add("VVTLOHNKD", OracleType.NVarChar).Value = dwData["VVTLOHNKD"].ToString();
            or1.Parameters.Add("VVTKOLL", OracleType.NVarChar).Value = dwData["VVTKOLL"].ToString();
            or1.Parameters.Add("VVTSANZSTK", OracleType.NVarChar).Value = dwData["VVTSANZSTK"].ToString();
            or1.Parameters.Add("VVTROHMTR", OracleType.NVarChar).Value = dwData["VVTROHMTR"].ToString();
            or1.Parameters.Add("VVTBRUTTO", OracleType.NVarChar).Value = dwData["VVTBRUTTO"].ToString();
            or1.Parameters.Add("VVTNETTO", OracleType.NVarChar).Value = dwData["VVTNETTO"].ToString();
            or1.Parameters.Add("VVTVERDERB", OracleType.NVarChar).Value = dwData["VVTVERDERB"].ToString();
            or1.Parameters.Add("VVTFOLGEMTR", OracleType.NVarChar).Value = dwData["VVTFOLGEMTR"].ToString();
            or1.Parameters.Add("VVTSOLLTEIL", OracleType.NVarChar).Value = dwData["VVTSOLLTEIL"].ToString();
            or1.Parameters.Add("VVTGEBNR", OracleType.NVarChar).Value = dwData["VVTGEBNR"].ToString();
            or1.Parameters.Add("VVTPROGRP", OracleType.NVarChar).Value = dwData["VVTPROGRP"].ToString();
            or1.Parameters.Add("VVTPLFDAT", OracleType.NVarChar).Value = dwData["VVTPLFDAT"].ToString();
            or1.Parameters.Add("VVTFBENID", OracleType.NVarChar).Value = dwData["VVTFBENID"].ToString();
            or1.Parameters.Add("VVTFDAT", OracleType.NVarChar).Value = dwData["VVTFDAT"].ToString();
            or1.Parameters.Add("VVTFZEIT", OracleType.NVarChar).Value = dwData["VVTFZEIT"].ToString();
            or1.Parameters.Add("VVTVBDAT", OracleType.NVarChar).Value = dwData["VVTVBDAT"].ToString();
            or1.Parameters.Add("VVTLIEFTERM", OracleType.NVarChar).Value = dwData["VVTLIEFTERM"].ToString();
            or1.Parameters.Add("VVTEILAUS", OracleType.NVarChar).Value = dwData["VVTEILAUS"].ToString();
            or1.Parameters.Add("VVTFRNETTO", OracleType.NVarChar).Value = dwData["VVTFRNETTO"].ToString();
            or1.Parameters.Add("VVTHUELTYP", OracleType.NVarChar).Value = dwData["VVTHUELTYP"].ToString();
            or1.Parameters.Add("VVTHUELGEW", OracleType.NVarChar).Value = dwData["VVTHUELGEW"].ToString();
            or1.Parameters.Add("VVTSPULEN", OracleType.NVarChar).Value = dwData["VVTSPULEN"].ToString();
            or1.Parameters.Add("VVTNETKG", OracleType.NVarChar).Value = dwData["VVTNETKG"].ToString();
            or1.Parameters.Add("VVTFEUCHTEI", OracleType.NVarChar).Value = dwData["VVTFEUCHTEI"].ToString();
            or1.Parameters.Add("VVTFEUCHTES", OracleType.NVarChar).Value = dwData["VVTFEUCHTES"].ToString();
            or1.Parameters.Add("VVTHGEWABZ", OracleType.NVarChar).Value = dwData["VVTHGEWABZ"].ToString();
            or1.Parameters.Add("VVTANZPA", OracleType.NVarChar).Value = dwData["VVTANZPA"].ToString();
            or1.Parameters.Add("VVTTARA", OracleType.NVarChar).Value = dwData["VVTTARA"].ToString();
            or1.Parameters.Add("VVTBRTGEW", OracleType.NVarChar).Value = dwData["VVTBRTGEW"].ToString();
            or1.Parameters.Add("VVTPACKTYP", OracleType.NVarChar).Value = dwData["VVTPACKTYP"].ToString();
            or1.Parameters.Add("VVTKREDLIM", OracleType.NVarChar).Value = dwData["VVTKREDLIM"].ToString();
            or1.Parameters.Add("VVTSWING", OracleType.NVarChar).Value = dwData["VVTSWING"].ToString();
            or1.Parameters.Add("VVTRAITING", OracleType.NVarChar).Value = dwData["VVTRAITING"].ToString();
            or1.Parameters.Add("VVTVERSICH1", OracleType.NVarChar).Value = dwData["VVTVERSICH1"].ToString();
            or1.Parameters.Add("VVTVERSICH2", OracleType.NVarChar).Value = dwData["VVTVERSICH2"].ToString();
            or1.Parameters.Add("VVTVERSICH3", OracleType.NVarChar).Value = dwData["VVTVERSICH3"].ToString();
            or1.Parameters.Add("VVTVERSICH4", OracleType.NVarChar).Value = dwData["VVTVERSICH4"].ToString();
            or1.Parameters.Add("VVTVERSICH5", OracleType.NVarChar).Value = dwData["VVTVERSICH5"].ToString();
            or1.Parameters.Add("VVTVERSICH21", OracleType.NVarChar).Value = dwData["VVTVERSICH21"].ToString();
            or1.Parameters.Add("VVTVERSICH22", OracleType.NVarChar).Value = dwData["VVTVERSICH22"].ToString();
            or1.Parameters.Add("VVTVERSICH23", OracleType.NVarChar).Value = dwData["VVTVERSICH23"].ToString();
            or1.Parameters.Add("VVTVERSICH24", OracleType.NVarChar).Value = dwData["VVTVERSICH24"].ToString();
            or1.Parameters.Add("VVTVERSICH25", OracleType.NVarChar).Value = dwData["VVTVERSICH25"].ToString();
            or1.Parameters.Add("VVTKREDBIS", OracleType.NVarChar).Value = dwData["VVTKREDBIS"].ToString();
            or1.Parameters.Add("VVTKREDVON", OracleType.NVarChar).Value = dwData["VVTKREDVON"].ToString();
            or1.Parameters.Add("VVTLUEBKZ", OracleType.NVarChar).Value = dwData["VVTLUEBKZ"].ToString();
            or1.Parameters.Add("VVTFKNVS", OracleType.NVarChar).Value = dwData["VVTFKNVS"].ToString();
            or1.Parameters.Add("VVTFKSPTD", OracleType.NVarChar).Value = dwData["VVTFKSPTD"].ToString();
            or1.Parameters.Add("VVTFKSPRD", OracleType.NVarChar).Value = dwData["VVTFKSPRD"].ToString();
            or1.Parameters.Add("VVTROHGEW", OracleType.NVarChar).Value = dwData["VVTROHGEW"].ToString();
            or1.Parameters.Add("VVTFERGEW", OracleType.NVarChar).Value = dwData["VVTFERGEW"].ToString();
            or1.Parameters.Add("VVTZUSTAND", OracleType.NVarChar).Value = dwData["VVTZUSTAND"].ToString();
            or1.Parameters.Add("VVTARTGRP", OracleType.NVarChar).Value = dwData["VVTARTGRP"].ToString();
            or1.Parameters.Add("VVTARTABW", OracleType.NVarChar).Value = dwData["VVTARTABW"].ToString();
            or1.Parameters.Add("VVTAPOS", OracleType.NVarChar).Value = dwData["VVTAPOS"].ToString();
            or1.Parameters.Add("VVTAUFMSL", OracleType.NVarChar).Value = dwData["VVTAUFMSL"].ToString();
            or1.Parameters.Add("VVTZENSUR", OracleType.NVarChar).Value = dwData["VVTZENSUR"].ToString();
            or1.Parameters.Add("VVTPOSEXT", OracleType.NVarChar).Value = dwData["VVTPOSEXT"].ToString();
            or1.Parameters.Add("VVTKZZUTEI", OracleType.NVarChar).Value = dwData["VVTKZZUTEI"].ToString();
            or1.Parameters.Add("VVTAKKREDNR", OracleType.NVarChar).Value = dwData["VVTAKKREDNR"].ToString();
            or1.Parameters.Add("VVTFILLER1", OracleType.NVarChar).Value = dwData["VVTFILLER1"].ToString();
            #endregion

            Connect2Proxy(or1);
        }
    }
}
